package cn.gson.crmdemo.model.mapper;

import java.math.BigDecimal;
import java.util.Date;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.alibaba.fastjson.JSONArray;
@Mapper
public interface BxMapper {
//查询报销表
	public JSONArray selectsp(@Param("reimDate")String reimDate,@Param("reimState")Integer reimState,@Param("reimName")Integer a);
	//是否审批
	public JSONArray selectzt(@Param("zt")Integer a);
	//查询审批人
	public JSONArray selectspr();
	//申请人
	public JSONArray selectsqr();
	//模糊查询
	public JSONArray selectsqrq(@Param("reim_date")String rq) ;
	//查询当前登录人
	public JSONArray selectsprcx(@Param("id")Integer a);
	//根据申请人模糊查询
	public JSONArray selectsqrcx(@Param("reim_name")Integer a);
	//根据name查询申请人
	public Integer selectsqrcxy(@Param("empName")String b);
	//报销申请查询
	public JSONArray selectbxsq(@Param("reimDate")String reimDate,@Param("reimState")Integer reimState,@Param("reimName")Integer a);
	public void insertReimbursement(@Param("reim_date")Date reim_date,@Param("reim_money")BigDecimal reim_money,@Param("reim_name")int reim_name,@Param("reim_record")String reim_record);
	
}
